AllDatesToYesterday

Basic and Crystal syntax.

Returns

None

Action

Specifies a range of Date values that includes every day up through the previous day. AllDatesToYesterday includes all dates before today, but does not include the present day.

Examples

The following examples are applicable to Crystal syntax:

If {orders.ORDER DATE} in AllDatesToYesterday Then

    {orders.ORDER AMOUNT}

Else

    0

Returns the Amount if the date falls on any date from the first date entered to yesterday. The following table identifies the first and last dates included in the date range if today equals 04/10/98.

If today = 04/10/98 {orders.ORDER DATE} {orders.ORDER AMOUNT}

first date included
(earliest date in field)

12/10/97

1252.24


01/05/98

1597.87


03/05/98

2546.35

last date included

04/09/98

5462.21

not in range

04/10/98

0

Note:    If you would like to base the date range on a date other than today's date, you must either change the date via the Date/Time option in the Windows Control Panel, or change the report print date via the Set Print Date/Time command in the Report Menu.



Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com